from tortoise import BaseDBAsyncClient


async def upgrade(db: BaseDBAsyncClient) -> str:
    return """
        ALTER TABLE `user` ADD `job_seeker_status` SMALLINT COMMENT '求职者状态(1:离职正在找工作 2:在职急需工作 3:在职找工作 4:在职没有找工作的打算)' DEFAULT 1;"""


async def downgrade(db: BaseDBAsyncClient) -> str:
    return """
        ALTER TABLE `user` DROP COLUMN `job_seeker_status`;"""
